<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Creating a percent-to-total shortcut metric</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ul.whs1 { list-style:disc; }
ol.whs2 { list-style:decimal; }
p.whs3 { margin-left:40px; }
p.whs4 { font-weight:bold; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nCalculating data on a report: Metrics\nPercent-to-total, rank, and transformation metrics: Shortcut metrics\nCreating a percent-to-total shortcut metric");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Creating a percent-to-total shortcut metric</h1>
<p>
<a href="Creating_a_shortcut_metric.htm">Shortcut metrics</a> are a 
 quick way to add new metrics based on the existing metrics of a report. 
 </p>
<p>Percent-to-total shortcut metrics display the percent in relation to 
 a selected total of each item affected by the metric. Use a percent-to-total 
 shortcut metric to show values as percents of an accumulated row or column 
 total. The metric can also total by page, for each value of the attribute, 
 or the grand total. </p>
<p>The following conditions apply to percent-to-total shortcut metrics:</p>
<ul type="disc" class="whs1">
	
<li class=p><p>Row and column percent totals refer to the uppermost 
 and extreme-left positions, respectively. </p></li>
	
<li class=p><p>Page percent totals affect all attributes on a page.</p></li>
	
<li class=p><p>In some cases, two or more percent-to-total calculations 
 at different logical levels yield the same result. For example, Percent-to-Page 
 Total data can be the same as Percent-to-Grand Total data on a single-page 
 report.</p></li>
	
<li class=p><p>The level of a percent-to-total shortcut metric remains 
 constant once the metric has been calculated; subsequent manipulation 
 does not affect it.</p></li>
</ul>
<h2><span><span style="font-weight: bold;"><B>Prerequisites</B></span></span></h2>
<ul type="disc" class="whs1">
	
<li class=p><p>You must have MicroStrategy OLAP Services to create 
 shortcut metrics. To evaluate OLAP Services, contact your MicroStrategy 
 Account Executive or e-mail MicroStrategy directly at <span class=Code>info@microstrategy.com</span>.</p></li>
	
<li class=p><p>Shortcut metrics are available only if DHTML is enabled. 
 See 
<a href="DHTML-only_features_in_Web.htm">Enabling DHTML in Web</a>.</p></li>
	
<li class=p><p>If a report does not contain attributes at a given percent-to-total 
 level, the level is unavailable for that report.</p></li>
</ul>
<h2>To create a percent-to-total shortcut metric</h2>
<ol>
<li class=p-Steps><p class=Steps style="margin-left: 0px;">Click the 
 name of a report to execute it. The report must be in either Grid view 
 or Grid and Graph view.</p></li>
</ol>
<ol start="2" type="1" class="whs2">
	
<li class=p><p>Right-click the column(s) or row(s) to see displayed 
 as percents of a total.</p></li>
	
<li class=p><p>Select <span style="font-weight: bold;"><B>Insert Metric 
 </B></span>and point to <span style="font-weight: bold;"><B>Percent To Total</B></span>. 
 A menu opens with the following options. Select the portions of the report 
 for which percent-to-total data is to be displayed:</p></li>
</ol>
<ul type="disc" class="whs1">
	<ul type="disc" class="whs1">
		
<li class=p><p><span style="font-weight: bold;"><B>Over Rows</B></span>: 
 Displays values in each row of the report as percents of a row total. 
 </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Over Columns</B></span>: 
 Displays values in each column as percents of a column total. </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Page Total</B></span>: 
 Displays all values on a page as percents of that page's total. This is 
 only displayed if there is an object in the Page-by field.</p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Grand Total</B></span>: 
 Displays all values in a report as percents of the grand total for that 
 report. </p></li>
		
<li class=p><p><span style="font-weight: bold;"><B>Total for Each</B></span>: 
 Displays all values pertaining to a given report component (an attribute, 
 for example) as percents of the total accumulated for that component. 
 </p></li>
	</ul>
</ul>
<p class="whs3">A new column of metric values is displayed 
 on the report.</p>
<p class="whs4">Related topics</p>
<ul type="disc" class="whs1">
	
<li class=p><p>
<a HREF="Creating_rank_shortcut_metrics.htm">Creating 
 rank shortcut metrics</a></p></li>
	
<li class=p><p>
<a HREF="Transformation_shortcut_metric.htm">Creating 
 a transformation shortcut metric</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
